Tabela ServiceHist

Definicja tabeli ServiceHist

Name

ServiceHist

Code

ServiceHist

Comment

 


Lista kolumn tabeli ServiceHist

Name

Code

ID

ID

HospID

HospID

ExtID

ExtID

Descr

Descr

Active

Active

TypeID

TypeID

UpdUserID

UpdUserID

UpdNr

UpdNr

UpdDate

UpdDate

UpdTime

UpdTime

LockUserID

LockUserID

LockTime

LockTime

ICD

ICD

Points

Points

Price

Price


Kolumna ID tabeli ServiceHist

Definicja kolumny ID tabeli ServiceHist

Name

ID

Code

ID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna HospID tabeli ServiceHist

Definicja kolumny HospID tabeli ServiceHist

Name

HospID

Code

HospID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ExtID tabeli ServiceHist

Definicja kolumny ExtID tabeli ServiceHist

Name

ExtID

Code

ExtID

Data Type

VARCHAR2(64)

Mandatory

No

Comment

Zewnetrzny identyfikator uslugi


Kolumna Descr tabeli ServiceHist

Definicja kolumny Descr tabeli ServiceHist

Name

Descr

Code

Descr

Data Type

VARCHAR2(512)

Mandatory

No

Comment

 


Kolumna Active tabeli ServiceHist

Definicja kolumny Active tabeli ServiceHist

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna TypeID tabeli ServiceHist

Definicja kolumny TypeID tabeli ServiceHist

Name

TypeID

Code

TypeID

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna UpdUserID tabeli ServiceHist

Definicja kolumny UpdUserID tabeli ServiceHist

Name

UpdUserID

Code

UpdUserID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna UpdNr tabeli ServiceHist

Definicja kolumny UpdNr tabeli ServiceHist

Name

UpdNr

Code

UpdNr

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna UpdDate tabeli ServiceHist

Definicja kolumny UpdDate tabeli ServiceHist

Name

UpdDate

Code

UpdDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna UpdTime tabeli ServiceHist

Definicja kolumny UpdTime tabeli ServiceHist

Name

UpdTime

Code

UpdTime

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna LockUserID tabeli ServiceHist

Definicja kolumny LockUserID tabeli ServiceHist

Name

LockUserID

Code

LockUserID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LockTime tabeli ServiceHist

Definicja kolumny LockTime tabeli ServiceHist

Name

LockTime

Code

LockTime

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ICD tabeli ServiceHist

Definicja kolumny ICD tabeli ServiceHist

Name

ICD

Code

ICD

Data Type

VARCHAR2(10)

Mandatory

No

Comment

 


Kolumna Points tabeli ServiceHist

Definicja kolumny Points tabeli ServiceHist

Name

Points

Code

Points

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Price tabeli ServiceHist

Definicja kolumny Price tabeli ServiceHist

Name

Price

Code

Price

Data Type

NUMBER(19,4)

Mandatory

No

Comment